﻿CREATE TABLE [dbo].[t_TradeReferences] (
    [ID]           INT            IDENTITY (1, 1) NOT NULL,
    [BorrowerID]   INT            NULL,
    [DatePulled]   SMALLDATETIME  NOT NULL,
    [FirmCode]     VARCHAR (50)   NULL,
    [IndustryCode] VARCHAR (50)   NULL,
    [ReportDate]   SMALLDATETIME  NULL,
    [OpenDate]     SMALLDATETIME  NULL,
    [HighCredit]   INT            NULL,
    [Ballance]     INT            NULL,
    [Term]         NUMERIC (7, 1) NOT NULL,
    [PastDue]      INT            NULL,
    [AccType]      CHAR (1)       NULL,
    [Status]       TINYINT        NULL,
    [MR]           SMALLINT       NULL,
    [ECOA]         CHAR (1)       NULL,
    [AccNumber]    VARCHAR (50)   NULL,
    [LastDate]     SMALLDATETIME  NULL,
    [AccountDesc]  VARCHAR (512)  NULL,
    [AccountState] BIT            NULL,
    [_30_]         TINYINT        NULL,
    [_60_]         TINYINT        NULL,
    [_90_]         TINYINT        NULL,
    [DD1]          SMALLDATETIME  NULL,
    [DD2]          SMALLDATETIME  NULL,
    [DD3]          SMALLDATETIME  NULL,
    [DS1]          TINYINT        NULL,
    [DS2]          TINYINT        NULL,
    [DS3]          TINYINT        NULL
);

